microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 36

Which of the following options is not available to remove arrows of Formula Auditing?

a) Remove all precedent arrows

b) Remove all dependent arrows

c) Remove all arrows

d) Remove all arrows for this cell

e) None of these

Answer: (d)

Question : 37

Which button do you click to add up a series of numbers?

a) The autosum button

b) The Formula button

c) The quicktotal button

d) The total button

e) None of these

Answer: (a)

Question : 38

Documentation should include

a) Destination and users of the output data

b) Source of input data

c) Information on the purpose of the workbook

d) All the above

e) None of these

Answer: (d)

Question : 39

The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

a) Click the Currency Style button on the formatting toolbar

b) You have to retype everything and manually add the dollar signs, commas, and decimals.

c) Select Format > Money from the menu

d) All the above

e) None of these

Answer: (a)

Question : 40

In Excel Book1 is an example of how … are numbered and named during each work session

a) Active cell

b) Formula bar

c) Menu bar

d) Name box

Answer: (d)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 7 Online Quiz

Click to Start..
413 microsoft excel qa based computer MCQ MS excel set 7 question answer with explanation pdf

Recently Added Subject & Categories For All Competitive Exams

100+ Quadratic Equation Questions Answers PDF for Bank

Quadratic Equation multiple choice questions with detailed answers for IBPS RRB SO. more than 250 Attitude practice test exercises for all competitive exams

03-Jul-2024 by Careericons

Continue Reading »

IBPS Aptitude Linear Equations MCQ Questions Answers PDF

Linear equations multiple choice questions with detailed answers for IBPS RRB SO. more than 250 Attitude practice test exercises for all competitive exams

03-Jul-2024 by Careericons

Continue Reading »

New 100+ Compound Interest MCQ with Answers PDF for IBPS

Compound Interest verbal ability questions and answers solutions with PDF for IBPS RRB PO. Aptitude Objective MCQ Practice Exercises all competitive exams

02-Jul-2024 by Careericons

Continue Reading »

100+ Mixture and Alligation MCQ Questions PDF for IBPS

Most importantly Mixture and Alligation multiple choice questions and answers with PDF for IBPS RRB PO. Aptitude MCQ Practice Exercises all Bank Exams

02-Jul-2024 by Careericons

Continue Reading »